Sep 23, 2016 17:18:12
2016
Jahr
09
Monat
23
Tag
17
Stunde (24)
18
Minute
12
Sekunde
Format
ISO 8601
Internationaler Standard zur Darstellung von Datum und Uhrzeit. Weit verbreitet in Webdiensten, Programmierung und Datenaustausch.YYYY-MM-DD'T'HH:MM:SS±hh:mm |
2016-09-23T17:18:12 |
|
ISO 8601 (Week)
Wird in Planung und Berichterstattung verwendet YYYY-Www-D |
2016-W38-5T17:18:12 |
|
RFC 3339
Wird in Internetprotokollen verwendet YYYY-MM-DD'T'HH:mm:ss'Z' |
2016-09-23T17:18:12Z |
|
RFC 822 / RFC 2822
Wird in E-Mail-Protokollen verwendet ddd, DD MMM YYYY HH:mm:ss 'GMT' |
Fr., 23 Sep 2016 17:18:12 +0000 |
|
RFC 7231
Das Format stimmt mit RFC 822 überein, aber RFC 7231 spezifiziert und standardisiert dessen Verwendung in HTTP Tag, DD Mon YYYY HH:MM:SS GMT |
Fr., 23 Sep 2016 17:18:12 +0000 |
|
UNIX Time (Epoch Time)
Weit verbreitet in der Programmierung Sekunden seit dem 1. Januar 1970 |
1474651092 |
|
ISO 9075
Ein Standard, der sich auf die SQL-Abfragesprache bezieht YYYY-MM-DD HH:MM:SS |
2016-09-23 17:18:12 |
|
USA
Datumsformat, das häufig in den USA verwendet wird MM/DD/YYYY HH:MM:SS |
09-23-2016 17:18:12 |
|
British/French, EU
Datumsformat, das häufig in Europa verwendet wird DD/MM/YY HH:MM:SS |
23/09/2016 17:18:12 |
|
German
Datumsformat, das häufig in Deutschland verwendet wird DD.MM.YYYY HH:MM:SS |
23.09.2016 17:18:12 |
|
Italian
Datumsformat, das häufig in Italien verwendet wird DD-MM-YYYY HH:MM:SS |
23-09-2016 17:18:12 |
|
Japan
Datumsformat, das häufig in Japan verwendet wird YYYY/MM/DD HH:MM:SS |
2016/09/23 17:18:12 |
|
Chinese Date
Format zur Darstellung von Daten im chinesischen Lunisolarkalender SS (Tier) (M'ter Monat), D, YYYY |
09 (Monkey) (9'th month), 23, 2016 |
|
Excel date/time
Intern von Excel verwendet, um einfache Berechnungen mit Datum und Uhrzeit zu ermöglichen Datum und Uhrzeit in Excel werden als Gleitkommazahlen gespeichert |
42636.720972222 |
|
Microsoft Timestamp / FileTime
Wird in Windows-System-APIs für die Verarbeitung von Datei- und Verzeichnis-Zeitstempeln verwendet 100 Nanosekunden seit dem 1. Januar 1601 |
131191246920000000 |
|
Text Date
Textuelle Darstellung eines Datums MMM DD, YYYY HH:MM:SS |
Sep 23, 2016 17:18:12 |
|
Mac Timestamp
Datums- und Zeitformat, das in macOS verwendet wird Sekunden seit dem 1. Januar 2001 |
496343892 |
|
Mongo ObjectID
Eindeutiges Identifikatorformat, das in MongoDB verwendet wird 12-stellige hexadezimale Zahl |
57e563d40000000000000000 |
|
Julian Day Number
Datumsformat, das in der Astronomie verwendet wird Anzahl der Tage seit dem 1. Januar 4713 v. Chr. |
2457655.22097 |
Welcher Wochentag 23/09/2016?
23 September 2016 is Freitag.
Wie lange ist es her 2016-09-23 17:18:12?
Aktuelle Zeit ist Samstag, Februar 8, 2025, 20:14:19
| Jahre | 8 |
| Monate | 100 |
| Wochen | 437 |
| Tage | 3060 |
| Stunden | 73442 |
| Minuten | 4406576 |
| Sekunden | 264394567 |
Seitennavigation
2016
Jahr
09
Monat
23
Tag
17
Stunde (24)
18
Minute
12
Sekunde
Wie war die Erfahrung?
%22%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M1.82799%208.9106H4.52539C5.3885%208.9106%206.09264%209.61372%206.09264%2010.4778V21.7258C6.09264%2022.5899%205.38952%2023.293%204.52539%2023.293H1.82799C0.963864%2023.293%200.260742%2022.5899%200.260742%2021.7258V10.4778C0.260742%209.61372%200.963864%208.9106%201.82799%208.9106ZM14.1593%208.9106H21.7876C22.8617%208.9106%2023.9561%209.84811%2023.6983%2011.0108L21.3617%2021.5291C21.1497%2022.4808%2020.4955%2023.293%2019.451%2023.293H9.28025C8.2164%2023.293%207.3482%2022.4217%207.3482%2021.3609H7.35126L7.35228%2010.2831C7.35228%209.77055%207.44399%209.31708%207.6427%208.84528L10.9414%201.01397C11.0667%200.716424%2011.3561%200.537076%2011.6598%200.537076V0.534019C12.8358%200.534019%2014.0871%200.348556%2014.8902%201.41852C15.3375%202.01466%2015.4465%202.76568%2015.2876%203.5228L14.1593%208.9106ZM21.7887%2010.4758H13.1983V10.4738C12.7081%2010.4738%2012.3331%2010.0193%2012.434%209.53423C12.6093%208.69251%2013.7913%203.26423%2013.7913%202.88623C13.7913%201.91919%2012.9435%202.09955%2012.1762%202.09955C11.7696%203.06558%209.04052%209.41199%208.95104%209.85625C8.85729%2010.3199%208.9113%2019.1396%208.9113%2021.3611H8.91435C8.91435%2021.569%209.08555%2021.728%209.28119%2021.728H19.4509C19.669%2021.728%2019.7933%2021.3988%2019.8392%2021.193L22.1768%2010.6768H22.1758C22.0882%2010.5637%2021.918%2010.53%2021.7886%2010.476L21.7887%2010.4758ZM22.1769%2010.6745C22.178%2010.6684%2022.1769%2010.6745%2022.1749%2010.6776H22.1759L22.1769%2010.6745ZM4.52546%2010.4758L1.82599%2010.4779L1.82802%2021.7279L4.5275%2021.7258L4.52546%2010.4758Z%22%20fill%3D%22white%22%2F%3E%3C%2Fg%3E%3Cdefs%3E%3CclipPath%20id%3D%22clip0_107_72%22%3E%3Crect%20width%3D%2224%22%20height%3D%2224%22%20fill%3D%22white%22%2F%3E%3C%2FclipPath%3E%3C%2Fdefs%3E%3C%2Fsvg%3E)
0
%22%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M22.172%2015.0894H19.4746C18.6115%2015.0894%2017.9074%2014.3863%2017.9074%2013.5222V2.27424C17.9074%201.41011%2018.6105%200.706985%2019.4746%200.706985H22.172C23.0361%200.706985%2023.7393%201.41011%2023.7393%202.27424V13.5222C23.7393%2014.3863%2023.0361%2015.0894%2022.172%2015.0894ZM9.8407%2015.0894H2.21235C1.1383%2015.0894%200.0438766%2014.1519%200.301695%2012.9892L2.6383%202.47093C2.85026%201.51918%203.50447%200.70701%204.54896%200.70701H14.7197C15.7836%200.70701%2016.6518%201.57826%2016.6518%202.63906H16.6487L16.6477%2013.7169C16.6477%2014.2294%2016.556%2014.6829%2016.3573%2015.1547L13.0586%2022.986C12.9333%2023.2836%2012.6439%2023.4629%2012.3402%2023.4629V23.466C11.1642%2023.466%209.91288%2023.6514%209.10984%2022.5815C8.6625%2021.9853%208.55346%2021.2343%208.71243%2020.4772L9.8407%2015.0894ZM2.21131%2013.5242H10.8017V13.5262C11.2919%2013.5262%2011.6669%2013.9807%2011.566%2014.4658C11.3907%2015.3075%2010.2087%2020.7358%2010.2087%2021.1138C10.2087%2022.0808%2011.0565%2021.9004%2011.8238%2021.9004C12.2304%2020.9344%2014.9595%2014.588%2015.049%2014.1438C15.1427%2013.6801%2015.0887%204.86045%2015.0887%202.63888H15.0856C15.0856%202.431%2014.9144%202.27205%2014.7188%202.27205H4.54907C4.331%202.27205%204.20668%202.60119%204.16082%202.80704L1.82319%2013.3232H1.82421C1.91185%2013.4363%202.08203%2013.47%202.21145%2013.524L2.21131%2013.5242ZM1.82306%2013.3255C1.82204%2013.3316%201.82306%2013.3255%201.8251%2013.3224H1.82408L1.82306%2013.3255ZM19.4745%2013.5242L22.174%2013.5221L22.172%202.27215L19.4725%202.27419L19.4745%2013.5242Z%22%20fill%3D%22white%22%2F%3E%3C%2Fg%3E%3Cdefs%3E%3CclipPath%20id%3D%22clip0_107_74%22%3E%3Crect%20width%3D%2224%22%20height%3D%2224%22%20fill%3D%22white%22%20transform%3D%22matrix(-1%200%200%20-1%2024%2024)%22%2F%3E%3C%2FclipPath%3E%3C%2Fdefs%3E%3C%2Fsvg%3E)
%22%3E%3Cpath%20d%3D%22M22.9122%203.25H2.1172C1.3633%203.25%200.75%203.86327%200.75%204.6172V19.3712C0.75%2020.1251%201.36327%2020.7384%202.1172%2020.7384H22.9112C23.6651%2020.7384%2024.2784%2020.1251%2024.2784%2019.3712L24.2794%204.6182C24.2794%203.8643%2023.6661%203.25%2022.9122%203.25ZM21.8605%204.7207L13.8184%2013.4015C13.4776%2013.7706%2013.0147%2013.9727%2012.5147%2013.9727C12.0147%2013.9727%2011.5519%2013.7696%2011.2111%2013.4005L3.16905%204.72073L21.8605%204.7207ZM2.2207%2019.2695V5.8612L10.132%2014.4002C10.7452%2015.0633%2011.6144%2015.4441%2012.5157%2015.4441C13.4171%2015.4441%2014.2853%2015.0633%2014.8986%2014.4012L22.8088%205.86118V19.2694L2.2207%2019.2695Z%22%20fill%3D%22%2356B46B%22%2F%3E%3C%2Fg%3E%3Cdefs%3E%3CclipPath%20id%3D%22clip0_107_77%22%3E%3Crect%20width%3D%2224%22%20height%3D%2224%22%20fill%3D%22white%22%20transform%3D%22translate(0.5)%22%2F%3E%3C%2FclipPath%3E%3C%2Fdefs%3E%3C%2Fsvg%3E)
Kontaktieren Sie uns